View Name:pd_amt_sched
View Number:5197
Group:Sales Mgr
Description:This view may be used to export period_amt, schedule and/or contract header level information. It provides the fields and the relations to tables likely to be used to furnish supporting information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
period_amt_objidperiod_amtobjidPeriod_amt internal record number 3 (UNIQUE)
schedule_objidcontr_scheduleobjidContr_schedule internal record number 
contract_objidcontractobjidContract internal record number 
bill_prd_amtperiod_amtbill_prd_amtThe amount billed 
prd_start_dtperiod_amtprd_start_dtThe start date of the current billing period 
prd_end_dtperiod_amtprd_end_dtThe last date of the current billing period 
rec_typeperiod_amtrec_typeType of detail record: i.e., 1=Invoice, 2=credit memo, 3=debit memo 
statusperiod_amtstatusStatus of the record: i.e., 0=hold, 1=approved, 2=disapproved 
pay_due_dtperiod_amtpay_due_dtDate when payment is due; usually equals either prd_start_dt or prd_end_dt 
last_gen_dtperiod_amtlast_gen_dtThe date time that the object was generated. This corresponds to a run of the aggregator function 
ref_start_dtperiod_amtref_start_dtThe start date of the reference billing period 
ref_end_dtperiod_amtref_end_dtThe last date of the reference billing period 
contract_idperiod_amtcontract_idContract that is referred to by the requester. This is the contract or other type of agreement under requestor claims entitlement 
schedule_idperiod_amtschedule_idContract schedule ID number 
schedule_titleperiod_amtschedule_titleContract schedule short description 
bill_groupperiod_amtbill_groupBilling group. This is from a user-defined popup list with default name BILLING_GROUP 
frequencyperiod_amtfrequencyFrequency of the billing: i.e., 0=annual, 1=semi-annual, 2=quarterly, 3=monthly, 4=one-time, default=0 
bill_optionperiod_amtbill_optionBilling option; i.e., 1=in advance, 2=in arrears 
item_start_dtperiod_amtitem_start_dtThe starting date for the contract line item 
item_end_dtperiod_amtitem_end_dtThe ending date for the line item 
due_offsetperiod_amtdue_offsetThe number of days in advance of the expected payment date that determines the invoice date 
cycle_start_dtperiod_amtcycle_start_dtThe starting date of the billing cycle. Used with schedule frequency to calculate the periodic 'as of' billing dates 
line_noperiod_amtline_noSequential line number of parent lines. For child lines,=parent's p_line_no 
svc_start_dateperiod_amtsvc_start_dateThe starting date for the line item 
svc_end_dateperiod_amtsvc_end_dateThe ending date for the line item 
chg_start_dtperiod_amtchg_start_dtThe date from which charges start to accrue 
chg_end_dtperiod_amtchg_end_dtThe last date through which charges accrue 
quantityperiod_amtquantityContracted/Quoted quantity of the part 
pro_prcperiod_amtpro_prcThe prorated price of the item 
net_prcperiod_amtnet_prcThe price after all adjustments (price factors) have been applied 
cov_site_idperiod_amtcov_site_idThe price after all adjustments (price factors) have been applied 
part_numperiod_amtpart_numberPart number/name 
unit_measureperiod_amtunit_measureUnit of measure for part number; e.g., roll, set, etc 
serial_noperiod_amtserial_noInstalled part serial number 
currencyperiod_amtcurrencyName of the currency 
bill_to_site_idperiod_amtbill_to_site_idSite ID of bill to site for the contract 
po_idperiod_amtpo_idThe unique purchase order ID 
org_idperiod_amtorg_idUser-specified ID number of the organization 
create_dtperiod_amtcreate_dtDate time the object was created 
appl_idperiod_amtappl_idClarify application identifier 
last_updateperiod_amtlast_updateDate time of last update to the corresponding contract item 
first_bill_dtperiod_amtfirst_bill_dtDate time billing started 
extracted_dtperiod_amtextracted_dtDate the item was extracted from the contract 
extract_trk_idperiod_amtextract_trk_idIdentifier used to track the period amount object 
status_dtperiod_amtstatus_dtDate time of last status change of the corresponding contract item 
invoice_noperiod_amtinvoice_noContract invoice number 
arch_indperiod_amtarch_indWhen set to 1, indicates the object is ready for purge/archive 
gross_prd_amtperiod_amtgross_prd_amtContains the undiscounted value of the line 

Joins:

Join FromJoin To
(period_amt).period2contr_schedule(contr_schedule).schedule2period_amt
(contr_schedule).schedule2contract(contract).contract2contr_schedule
My Recent Objects
pd_amt_sched