10: c_deactivated CONSTANT varchar(12) := 'DEACTIVATED';
11:
12: /* AP Credit Card Transactions */
13: ---------------------------------------------------------------------------------------------------
14: SUBTYPE ccTrxn_trxID IS AP_CREDIT_CARD_TRXNS.trx_id%TYPE;
15: SUBTYPE ccTrxn_validateCode IS AP_CREDIT_CARD_TRXNS.validate_code%TYPE;
16: SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
11:
12: /* AP Credit Card Transactions */
13: ---------------------------------------------------------------------------------------------------
14: SUBTYPE ccTrxn_trxID IS AP_CREDIT_CARD_TRXNS.trx_id%TYPE;
15: SUBTYPE ccTrxn_validateCode IS AP_CREDIT_CARD_TRXNS.validate_code%TYPE;
16: SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
12: /* AP Credit Card Transactions */
13: ---------------------------------------------------------------------------------------------------
14: SUBTYPE ccTrxn_trxID IS AP_CREDIT_CARD_TRXNS.trx_id%TYPE;
15: SUBTYPE ccTrxn_validateCode IS AP_CREDIT_CARD_TRXNS.validate_code%TYPE;
16: SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
13: ---------------------------------------------------------------------------------------------------
14: SUBTYPE ccTrxn_trxID IS AP_CREDIT_CARD_TRXNS.trx_id%TYPE;
15: SUBTYPE ccTrxn_validateCode IS AP_CREDIT_CARD_TRXNS.validate_code%TYPE;
16: SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
14: SUBTYPE ccTrxn_trxID IS AP_CREDIT_CARD_TRXNS.trx_id%TYPE;
15: SUBTYPE ccTrxn_validateCode IS AP_CREDIT_CARD_TRXNS.validate_code%TYPE;
16: SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
15: SUBTYPE ccTrxn_validateCode IS AP_CREDIT_CARD_TRXNS.validate_code%TYPE;
16: SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
16: SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
17: SUBTYPE ccTrxn_expensedAmt IS AP_CREDIT_CARD_TRXNS.expensed_amount%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
18: SUBTYPE ccTrxn_cardId IS AP_CREDIT_CARD_TRXNS.card_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
19: SUBTYPE ccTrxn_refNum IS AP_CREDIT_CARD_TRXNS.reference_number%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
20: SUBTYPE ccTrxn_folioType IS AP_CREDIT_CARD_TRXNS.folio_type%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
21: SUBTYPE ccTrxn_category IS AP_CREDIT_CARD_TRXNS.category%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
22: SUBTYPE ccTrxn_headerID IS AP_CREDIT_CARD_TRXNS.report_header_id%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
23: SUBTYPE ccTrxn_expenseStatus IS AP_CREDIT_CARD_TRXNS.expense_status%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
24: SUBTYPE ccTrxn_billedCurrCode IS AP_CREDIT_CARD_TRXNS.billed_currency_code%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
32: SUBTYPE ccTrxn_merchantProv IS AP_CREDIT_CARD_TRXNS.merchant_province_state%TYPE;
25: SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
32: SUBTYPE ccTrxn_merchantProv IS AP_CREDIT_CARD_TRXNS.merchant_province_state%TYPE;
33: SUBTYPE ccTrxn_transDate IS AP_CREDIT_CARD_TRXNS.transaction_date%TYPE;
26: SUBTYPE ccTrxn_companyPrepaidInvID IS AP_CREDIT_CARD_TRXNS.company_prepaid_invoice_id%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
32: SUBTYPE ccTrxn_merchantProv IS AP_CREDIT_CARD_TRXNS.merchant_province_state%TYPE;
33: SUBTYPE ccTrxn_transDate IS AP_CREDIT_CARD_TRXNS.transaction_date%TYPE;
34: SUBTYPE ccTrxn_paymentDueFromCode IS AP_CREDIT_CARD_TRXNS.payment_due_from_code%TYPE;
27: SUBTYPE ccTrxn_merchantName1 IS AP_CREDIT_CARD_TRXNS.merchant_name1%TYPE;
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
32: SUBTYPE ccTrxn_merchantProv IS AP_CREDIT_CARD_TRXNS.merchant_province_state%TYPE;
33: SUBTYPE ccTrxn_transDate IS AP_CREDIT_CARD_TRXNS.transaction_date%TYPE;
34: SUBTYPE ccTrxn_paymentDueFromCode IS AP_CREDIT_CARD_TRXNS.payment_due_from_code%TYPE;
35:
28: SUBTYPE ccTrxn_merchantCity IS AP_CREDIT_CARD_TRXNS.merchant_city%TYPE;
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
32: SUBTYPE ccTrxn_merchantProv IS AP_CREDIT_CARD_TRXNS.merchant_province_state%TYPE;
33: SUBTYPE ccTrxn_transDate IS AP_CREDIT_CARD_TRXNS.transaction_date%TYPE;
34: SUBTYPE ccTrxn_paymentDueFromCode IS AP_CREDIT_CARD_TRXNS.payment_due_from_code%TYPE;
35:
36:
29: SUBTYPE ccTrxn_billedAmount IS AP_CREDIT_CARD_TRXNS.billed_amount%TYPE;
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
32: SUBTYPE ccTrxn_merchantProv IS AP_CREDIT_CARD_TRXNS.merchant_province_state%TYPE;
33: SUBTYPE ccTrxn_transDate IS AP_CREDIT_CARD_TRXNS.transaction_date%TYPE;
34: SUBTYPE ccTrxn_paymentDueFromCode IS AP_CREDIT_CARD_TRXNS.payment_due_from_code%TYPE;
35:
36:
37: ---------------------------------------------------------------------------------------------------
30: SUBTYPE ccTrxn_postedCurrCode IS AP_CREDIT_CARD_TRXNS.posted_currency_code%TYPE;
31: SUBTYPE ccTrxn_trxnAmount IS AP_CREDIT_CARD_TRXNS.transaction_amount%TYPE;
32: SUBTYPE ccTrxn_merchantProv IS AP_CREDIT_CARD_TRXNS.merchant_province_state%TYPE;
33: SUBTYPE ccTrxn_transDate IS AP_CREDIT_CARD_TRXNS.transaction_date%TYPE;
34: SUBTYPE ccTrxn_paymentDueFromCode IS AP_CREDIT_CARD_TRXNS.payment_due_from_code%TYPE;
35:
36:
37: ---------------------------------------------------------------------------------------------------
38: /* AP Card Programs */